package com.dbxt.dao;

import org.apache.ibatis.annotations.Param;

import com.dbxt.entity.Clerk;
import com.dbxt.entity.Student;
import com.dbxt.entity.Teacher;

public interface CommonMapper {
	public Student findOneStudent(String username);//根据账户查询学生（注意学生账号SQL是sno）

	public Teacher findOneTeacher(String username);//根据账户查询老师

	public Clerk findOneClerk(String username);//根据账户查询书记员
	
	public Student studentLogin(@Param("username")String username,@Param("password")String password);//学生登录（注意学生账号SQL是sno）
	
	public Teacher teacherLogin(@Param("username")String username,@Param("password")String password);//老师登录
	
	public Clerk clerkLogin(@Param("username")String username,@Param("password")String password);//书记员登录
	
	public void changeStudentPassword(@Param("password")String password,@Param("sid")Integer sid);//修改学生密码
	
	public void changeClerkPassword(@Param("password")String password,@Param("cid")Integer cid);//修改书记员密码
	
	public void changeTeacherPassword(@Param("password")String password,@Param("tid")Integer tid);//修改老师密码
}
